Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	950
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	96.6 KiB
Average record size in memory	104.1 B

Variable types

Categorical	1
Numeric	12

Alerts

`amperestunden` is highly correlated with `zyklus_` and 5 other fields	High correlation
`zyklus_` is highly correlated with `amperestunden` and 4 other fields	High correlation
`temperature_amax` is highly correlated with `temperature_amin` and 3 other fields	High correlation
`temperature_amin` is highly correlated with `temperature_amax` and 3 other fields	High correlation
`temperature_mean` is highly correlated with `temperature_amax` and 3 other fields	High correlation
`time_amin` is highly correlated with `amperestunden` and 6 other fields	High correlation
`time_entladen_stark_vorher` is highly correlated with `amperestunden` and 6 other fields	High correlation
`time_entladen_leicht_vorher` is highly correlated with `amperestunden` and 3 other fields	High correlation
`time_laden_stark_vorher` is highly correlated with `amperestunden` and 4 other fields	High correlation
`time_pause_vorher` is highly correlated with `amperestunden` and 5 other fields	High correlation
`time_temp_hoch` is highly correlated with `temperature_amax` and 3 other fields	High correlation
`time_temp_hoch_vorher` is highly correlated with `temperature_amax` and 7 other fields	High correlation
`amperestunden` is highly correlated with `zyklus_` and 4 other fields	High correlation
`zyklus_` is highly correlated with `amperestunden` and 2 other fields	High correlation
`temperature_amax` is highly correlated with `temperature_amin` and 1 other fields	High correlation
`temperature_amin` is highly correlated with `temperature_amax` and 1 other fields	High correlation
`temperature_mean` is highly correlated with `temperature_amax` and 1 other fields	High correlation
`time_amin` is highly correlated with `amperestunden` and 5 other fields	High correlation
`time_entladen_stark_vorher` is highly correlated with `amperestunden` and 3 other fields	High correlation
`time_entladen_leicht_vorher` is highly correlated with `amperestunden` and 2 other fields	High correlation
`time_laden_stark_vorher` is highly correlated with `amperestunden` and 3 other fields	High correlation
`time_pause_vorher` is highly correlated with `time_amin` and 2 other fields	High correlation
`time_temp_hoch` is highly correlated with `time_temp_hoch_vorher`	High correlation
`time_temp_hoch_vorher` is highly correlated with `time_temp_hoch`	High correlation
`amperestunden` is highly correlated with `zyklus_` and 4 other fields	High correlation
`zyklus_` is highly correlated with `amperestunden` and 3 other fields	High correlation
`temperature_amax` is highly correlated with `temperature_amin` and 2 other fields	High correlation
`temperature_amin` is highly correlated with `temperature_amax` and 2 other fields	High correlation
`temperature_mean` is highly correlated with `temperature_amax` and 2 other fields	High correlation
`time_amin` is highly correlated with `amperestunden` and 4 other fields	High correlation
`time_entladen_stark_vorher` is highly correlated with `amperestunden` and 4 other fields	High correlation
`time_entladen_leicht_vorher` is highly correlated with `amperestunden` and 2 other fields	High correlation
`time_laden_stark_vorher` is highly correlated with `amperestunden` and 3 other fields	High correlation
`time_pause_vorher` is highly correlated with `time_amin` and 1 other fields	High correlation
`time_temp_hoch` is highly correlated with `temperature_amax` and 2 other fields	High correlation
`batteryname_` is highly correlated with `amperestunden` and 9 other fields	High correlation
`amperestunden` is highly correlated with `batteryname_` and 7 other fields	High correlation
`zyklus_` is highly correlated with `batteryname_` and 8 other fields	High correlation
`temperature_amax` is highly correlated with `batteryname_` and 2 other fields	High correlation
`temperature_amin` is highly correlated with `batteryname_` and 3 other fields	High correlation
`temperature_mean` is highly correlated with `batteryname_` and 2 other fields	High correlation
`time_amin` is highly correlated with `amperestunden` and 7 other fields	High correlation
`time_entladen_stark_vorher` is highly correlated with `batteryname_` and 8 other fields	High correlation
`time_entladen_leicht_vorher` is highly correlated with `batteryname_` and 8 other fields	High correlation
`time_laden_stark_vorher` is highly correlated with `amperestunden` and 6 other fields	High correlation
`time_pause_vorher` is highly correlated with `batteryname_` and 6 other fields	High correlation
`time_temp_hoch` is highly correlated with `batteryname_` and 6 other fields	High correlation
`time_temp_hoch_vorher` is highly correlated with `batteryname_` and 9 other fields	High correlation
`time_amin` has unique values	Unique
`time_entladen_leicht_vorher` has unique values	Unique
`time_laden_stark_vorher` has unique values	Unique
`time_entladen_stark_vorher` has 40 (4.2%) zeros	Zeros
`time_pause_vorher` has 22 (2.3%) zeros	Zeros
`time_temp_hoch` has 593 (62.4%) zeros	Zeros
`time_temp_hoch_vorher` has 33 (3.5%) zeros	Zeros

Reproduction

Analysis started	2021-12-12 19:01:15.368392
Analysis finished	2021-12-12 19:01:33.757732
Duration	18.39 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

batteryname_
Categorical

HIGH CORRELATION

Distinct	28
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Memory size	7.5 KiB

RW9	80
RW11	77
RW10	77
RW12	76
RW2	52
Other values (23)	588

Length

Max length	4
Median length	4
Mean length	3.554736842
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RW1
2nd row	RW1
3rd row	RW1
4th row	RW1
5th row	RW1

Common Values

Value	Count	Frequency (%)
RW9	80	8.4%
RW11	77	8.1%
RW10	77	8.1%
RW12	76	8.0%
RW2	52	5.5%
RW7	49	5.2%
RW8	48	5.1%
RW1	48	5.1%
RW3	44	4.6%
RW5	42	4.4%
Other values (18)	357	37.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
rw9	80	8.4%
rw11	77	8.1%
rw10	77	8.1%
rw12	76	8.0%
rw2	52	5.5%
rw7	49	5.2%
rw8	48	5.1%
rw1	48	5.1%
rw3	44	4.6%
rw5	42	4.4%
Other values (18)	357	37.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

amperestunden
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	948
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5014888

Minimum	0
Maximum	2.147192722
Zeros	3
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1.011283349
Q1	1.253411514
median	1.491576156
Q3	1.754460949
95-th percentile	2.043836863
Maximum	2.147192722
Range	2.147192722
Interquartile range (IQR)	0.5010494347

Descriptive statistics

Standard deviation	0.3325745011
Coefficient of variation (CV)	0.2214964914
Kurtosis	0.2232667832
Mean	1.5014888
Median Absolute Deviation (MAD)	0.2526541546
Skewness	-0.2003476861
Sum	1426.41436
Variance	0.1106057988
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3	0.3%
1.781939909	1	0.1%
1.746756154	1	0.1%
2.008983757	1	0.1%
2.002933988	1	0.1%
1.943405937	1	0.1%
1.94311155	1	0.1%
1.863253171	1	0.1%
1.86467005	1	0.1%
1.801244912	1	0.1%
Other values (938)	938	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3	0.3%
0.6929784044	1	0.1%
0.7487782114	1	0.1%
0.750202993	1	0.1%
0.758739532	1	0.1%
0.7597755255	1	0.1%
0.7783643746	1	0.1%
0.7849392036	1	0.1%
0.8116476265	1	0.1%
0.8168337649	1	0.1%

Value	Count	Frequency (%)
2.147192722	1	0.1%
2.141582404	1	0.1%
2.138831784	1	0.1%
2.137437355	1	0.1%
2.136908838	1	0.1%
2.134823039	1	0.1%
2.134648283	1	0.1%
2.133916152	1	0.1%
2.132614816	1	0.1%
2.131995793	1	0.1%

zyklus_
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	861
Distinct (%)	90.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28218.97053

Minimum	1
Maximum	113576
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	1
5-th percentile	865.8
Q1	7952.75
median	16073
Q3	39511.25
95-th percentile	93463.65
Maximum	113576
Range	113575
Interquartile range (IQR)	31558.5

Descriptive statistics

Standard deviation	28321.90788
Coefficient of variation (CV)	1.003647807
Kurtosis	0.8231802114
Mean	28218.97053
Median Absolute Deviation (MAD)	11970.5
Skewness	1.327962722
Sum	26808022
Variance	802130466
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	19	2.0%
3	8	0.8%
5	5	0.5%
1	4	0.4%
24209	4	0.4%
3031	4	0.4%
3033	4	0.4%
6057	4	0.4%
9087	4	0.4%
12111	4	0.4%
Other values (851)	890	93.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	4	0.4%
2	19	2.0%
3	8	0.8%
4	3	0.3%
5	5	0.5%
9	1	0.1%
40	1	0.1%
47	2	0.2%
854	1	0.1%
856	1	0.1%

Value	Count	Frequency (%)
113576	1	0.1%
113572	1	0.1%
110817	1	0.1%
110555	1	0.1%
110551	1	0.1%
109387	1	0.1%
109199	1	0.1%
109195	1	0.1%
107800	1	0.1%
107796	1	0.1%

temperature_amax
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	810
Distinct (%)	85.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-343.1336119

Minimum	-4099.44775
Maximum	44.93351
Zeros	0
Zeros (%)	0.0%
Negative	90
Negative (%)	9.5%
Memory size	7.5 KiB

Quantile statistics

Minimum	-4099.44775
5-th percentile	-4093.927
Q1	24.64716
median	27.059845
Q3	34.33386
95-th percentile	43.01202
Maximum	44.93351
Range	4144.38126
Interquartile range (IQR)	9.6867

Descriptive statistics

Standard deviation	1183.820648
Coefficient of variation (CV)	-3.450028231
Kurtosis	6.184014818
Mean	-343.1336119
Median Absolute Deviation (MAD)	3.35148
Skewness	-2.858384352
Sum	-325976.9313
Variance	1401431.326
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-4093.927	48	5.1%
-4094.09814	34	3.6%
24.43581	4	0.4%
24.33748	3	0.3%
24.46182	3	0.3%
23.67316	3	0.3%
24.2646	3	0.3%
27.25782	3	0.3%
23.31518	3	0.3%
43.09319	2	0.2%
Other values (800)	844	88.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4099.44775	2	0.2%
-4094.09814	34	3.6%
-4093.927	48	5.1%
-4059.5376	2	0.2%
-70.1011	1	0.1%
-63.09559	1	0.1%
-57.93151	1	0.1%
-54.88553	1	0.1%
22.08074	1	0.1%
22.64744	1	0.1%

Value	Count	Frequency (%)
44.93351	1	0.1%
44.77131	1	0.1%
44.75011	1	0.1%
44.66674	1	0.1%
44.43338	1	0.1%
44.32677	1	0.1%
44.27815	1	0.1%
44.09966	1	0.1%
44.0831	1	0.1%
44.07764	1	0.1%

temperature_amin
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	807
Distinct (%)	84.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-369.2755797

Minimum	-4099.44775
Maximum	40.65417
Zeros	0
Zeros (%)	0.0%
Negative	91
Negative (%)	9.6%
Memory size	7.5 KiB

Quantile statistics

Minimum	-4099.44775
5-th percentile	-4093.927
Q1	19.4810675
median	21.80882
Q3	28.5679825
95-th percentile	38.9023835
Maximum	40.65417
Range	4140.10192
Interquartile range (IQR)	9.086915

Descriptive statistics

Standard deviation	1212.788638
Coefficient of variation (CV)	-3.284237314
Kurtosis	5.580768786
Mean	-369.2755797
Median Absolute Deviation (MAD)	3.336185
Skewness	-2.751126451
Sum	-350811.8007
Variance	1470856.28
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-4093.927	52	5.5%
-4094.09814	34	3.6%
-4099.44775	3	0.3%
28.66285	3	0.3%
21.06748	3	0.3%
19.5299	3	0.3%
20.98965	3	0.3%
19.71828	3	0.3%
19.16685	3	0.3%
19.02537	2	0.2%
Other values (797)	841	88.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4099.44775	3	0.3%
-4094.09814	34	3.6%
-4093.927	52	5.5%
-4059.5376	2	0.2%
16.49812	1	0.1%
17.1661	1	0.1%
17.38354	1	0.1%
17.5044	1	0.1%
17.53201	1	0.1%
17.55559	1	0.1%

Value	Count	Frequency (%)
40.65417	1	0.1%
40.64124	1	0.1%
40.56391	1	0.1%
40.56279	1	0.1%
40.41031	1	0.1%
40.32174	1	0.1%
40.24242	1	0.1%
40.21308	1	0.1%
40.11925	1	0.1%
39.8741	1	0.1%

temperature_mean
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	870
Distinct (%)	91.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-362.7266643

Minimum	-4099.44775
Maximum	42.14114416
Zeros	0
Zeros (%)	0.0%
Negative	91
Negative (%)	9.6%
Memory size	7.5 KiB

Quantile statistics

Minimum	-4099.44775
5-th percentile	-4093.927
Q1	22.3161411
median	24.4982451
Q3	31.68772172
95-th percentile	41.02405727
Maximum	42.14114416
Range	4141.588894
Interquartile range (IQR)	9.371580623

Descriptive statistics

Standard deviation	1206.597105
Coefficient of variation (CV)	-3.326463765
Kurtosis	5.690477797
Mean	-362.7266643
Median Absolute Deviation (MAD)	3.192067399
Skewness	-2.770344446
Sum	-344590.331
Variance	1455876.574
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-4093.927	39	4.1%
-4094.09814	29	3.1%
-4093.927	9	0.9%
-4094.09814	5	0.5%
-4059.5376	2	0.2%
-4099.44775	2	0.2%
23.91183181	1	0.1%
41.20798725	1	0.1%
41.01648279	1	0.1%
41.50360734	1	0.1%
Other values (860)	860	90.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4099.44775	2	0.2%
-4094.09814	5	0.5%
-4094.09814	29	3.1%
-4093.927	9	0.9%
-4093.927	39	4.1%
-4086.816011	1	0.1%
-4059.5376	2	0.2%
-4036.99036	1	0.1%
-4004.962801	1	0.1%
-3925.289877	1	0.1%

Value	Count	Frequency (%)
42.14114416	1	0.1%
42.11761987	1	0.1%
42.0327026	1	0.1%
41.91600623	1	0.1%
41.82337826	1	0.1%
41.81604031	1	0.1%
41.80844105	1	0.1%
41.75436561	1	0.1%
41.73001796	1	0.1%
41.69768148	1	0.1%

time_amin
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6860446.252

Minimum	1633.73
Maximum	17577173.69
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	1633.73
5-th percentile	444543.7585
Q1	3126158.735
median	6566721.22
Q3	10263763.56
95-th percentile	14223182.87
Maximum	17577173.69
Range	17575539.96
Interquartile range (IQR)	7137604.822

Descriptive statistics

Standard deviation	4348495.994
Coefficient of variation (CV)	0.6338503115
Kurtosis	-0.8259038793
Mean	6860446.252
Median Absolute Deviation (MAD)	3508038.04
Skewness	0.2879996498
Sum	6517423939
Variance	1.890941741 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
385232.92	1	0.1%
3171585.87	1	0.1%
7858868.92	1	0.1%
208842.46	1	0.1%
226891.06	1	0.1%
814826.12	1	0.1%
832841.17	1	0.1%
1405694.42	1	0.1%
1424061.95	1	0.1%
2006333.65	1	0.1%
Other values (940)	940	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1633.73	1	0.1%
6294.22	1	0.1%
9754.78	1	0.1%
9800.31	1	0.1%
9800.84	1	0.1%
9813.11	1	0.1%
9849.62	1	0.1%
9966.34	1	0.1%
10018.01	1	0.1%
10092.75	1	0.1%

Value	Count	Frequency (%)
17577173.69	1	0.1%
17485573.05	1	0.1%
17470024.95	1	0.1%
17298505.87	1	0.1%
17085565.63	1	0.1%
17083278.63	1	0.1%
17054456.08	1	0.1%
16966176.51	1	0.1%
16941806.02	1	0.1%
16873033.81	1	0.1%

time_entladen_stark_vorher
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	597
Distinct (%)	62.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	205013.9202

Minimum	0
Maximum	593181.15
Zeros	40
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	0
5-th percentile	22304.7675
Q1	123008.6775
median	203374.52
Q3	264311.3625
95-th percentile	480312.196
Maximum	593181.15
Range	593181.15
Interquartile range (IQR)	141302.685

Descriptive statistics

Standard deviation	123505.3834
Coefficient of variation (CV)	0.602424378
Kurtosis	0.8246641979
Mean	205013.9202
Median Absolute Deviation (MAD)	69319.5
Skewness	0.7630255465
Sum	194763224.2
Variance	1.525357972 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	40	4.2%
239704.04	4	0.4%
201767.84	2	0.2%
45712.61	2	0.2%
26248.56	2	0.2%
228812.91	2	0.2%
226026.61	2	0.2%
221762.48	2	0.2%
219154.11	2	0.2%
214002.42	2	0.2%
Other values (587)	890	93.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	40	4.2%
1441.61	1	0.1%
1597.06	1	0.1%
1616.74	1	0.1%
17749.62	2	0.2%
19338.98	1	0.1%
21926.61	2	0.2%
22766.96	2	0.2%
23109.02	1	0.1%
23298.04	1	0.1%

Value	Count	Frequency (%)
593181.15	1	0.1%
590747.87	1	0.1%
588001.68	1	0.1%
584509.3	1	0.1%
581060.04	1	0.1%
577898.06	1	0.1%
574226.15	1	0.1%
570478.33	1	0.1%
566288.94	1	0.1%
562124.13	1	0.1%

time_entladen_leicht_vorher
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1358084.162

Minimum	7538.12
Maximum	4347433.06
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	7538.12
5-th percentile	123876.6955
Q1	468996.755
median	1105874.61
Q3	1896081.998
95-th percentile	3784764.458
Maximum	4347433.06
Range	4339894.94
Interquartile range (IQR)	1427085.243

Descriptive statistics

Standard deviation	1094643.005
Coefficient of variation (CV)	0.8060200065
Kurtosis	0.1013639948
Mean	1358084.162
Median Absolute Deviation (MAD)	679998.72
Skewness	0.9663618627
Sum	1290179954
Variance	1.198243308 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
196178.5	1	0.1%
714809.15	1	0.1%
337253.44	1	0.1%
198416.22	1	0.1%
205627.7	1	0.1%
318912.52	1	0.1%
325908.51	1	0.1%
420498.37	1	0.1%
427212.08	1	0.1%
517643.84	1	0.1%
Other values (940)	940	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7538.12	1	0.1%
7539.59	1	0.1%
7542.95	1	0.1%
7552.6	1	0.1%
7610.03	1	0.1%
7616.33	1	0.1%
7629.05	1	0.1%
7634.98	1	0.1%
7661.04	1	0.1%
7665.27	1	0.1%

Value	Count	Frequency (%)
4347433.06	1	0.1%
4343519.61	1	0.1%
4268724.25	1	0.1%
4264733.78	1	0.1%
4234224.36	1	0.1%
4200003.53	1	0.1%
4184108.45	1	0.1%
4179980.68	1	0.1%
4159345.36	1	0.1%
4155906	1	0.1%

time_laden_stark_vorher
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3649026.058

Minimum	1627.08
Maximum	10850409.36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	1627.08
5-th percentile	180774.203
Q1	1667120.555
median	3387895.06
Q3	5026416.302
95-th percentile	8405080.343
Maximum	10850409.36
Range	10848782.28
Interquartile range (IQR)	3359295.747

Descriptive statistics

Standard deviation	2470853.712
Coefficient of variation (CV)	0.6771269025
Kurtosis	-0.3779777288
Mean	3649026.058
Median Absolute Deviation (MAD)	1671319.635
Skewness	0.5570831566
Sum	3466574755
Variance	6.105118064 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
194718.28	1	0.1%
2211298.91	1	0.1%
4734429.79	1	0.1%
11155.93	1	0.1%
21971.54	1	0.1%
444310.17	1	0.1%
455328.22	1	0.1%
881343.11	1	0.1%
893002.1	1	0.1%
1333416.55	1	0.1%
Other values (940)	940	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1627.08	1	0.1%
6289.18	1	0.1%
9394.74	1	0.1%
9440.27	1	0.1%
9440.8	1	0.1%
9453.07	1	0.1%
9489.58	1	0.1%
9606.3	1	0.1%
9657.97	1	0.1%
9732.74	1	0.1%

Value	Count	Frequency (%)
10850409.36	1	0.1%
10769780.97	1	0.1%
10468424.33	1	0.1%
10381041.46	1	0.1%
10306316.74	1	0.1%
10086358.66	1	0.1%
9995981.55	1	0.1%
9910653.22	1	0.1%
9763684.43	1	0.1%
9702559.45	1	0.1%

time_pause_vorher
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	798
Distinct (%)	84.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1050077.314

Minimum	0
Maximum	5585429.23
Zeros	22
Zeros (%)	2.3%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	0
5-th percentile	16047.58
Q1	129139.4
median	648877.985
Q3	1504034.133
95-th percentile	3759876.513
Maximum	5585429.23
Range	5585429.23
Interquartile range (IQR)	1374894.733

Descriptive statistics

Standard deviation	1183726.529
Coefficient of variation (CV)	1.127275595
Kurtosis	2.110042012
Mean	1050077.314
Median Absolute Deviation (MAD)	555902.795
Skewness	1.575044181
Sum	997573448.2
Variance	1.401208495 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	22	2.3%
300	16	1.7%
14570.71	2	0.2%
16048.39	2	0.2%
16047.58	2	0.2%
28480.9	2	0.2%
43308.44	2	0.2%
54539.1	2	0.2%
68173.6	2	0.2%
79399.1	2	0.2%
Other values (788)	896	94.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	22	2.3%
300	16	1.7%
11400	1	0.1%
14570.71	2	0.2%
14574.91	2	0.2%
15817.74	2	0.2%
16046.88	2	0.2%
16047.58	2	0.2%
16048.39	2	0.2%
16065.26	2	0.2%

Value	Count	Frequency (%)
5585429.23	1	0.1%
5470150.93	1	0.1%
5378402.95	1	0.1%
5338495.03	1	0.1%
5302217.34	1	0.1%
5261931.65	1	0.1%
5170176.72	1	0.1%
5130269.14	1	0.1%
5093991.63	1	0.1%
5053697.84	1	0.1%

time_temp_hoch
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	358
Distinct (%)	37.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1977.097947

Minimum	0
Maximum	7730.64
Zeros	593
Zeros (%)	62.4%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4522.975
95-th percentile	6904.285
Maximum	7730.64
Range	7730.64
Interquartile range (IQR)	4522.975

Descriptive statistics

Standard deviation	2664.734842
Coefficient of variation (CV)	1.347801127
Kurtosis	-1.11352209
Mean	1977.097947
Median Absolute Deviation (MAD)	0
Skewness	0.764488618
Sum	1878243.05
Variance	7100811.776
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	593	62.4%
5552.06	1	0.1%
4684.59	1	0.1%
4439.53	1	0.1%
4436.76	1	0.1%
4376.34	1	0.1%
4364.01	1	0.1%
4495.3	1	0.1%
4513.65	1	0.1%
4784.88	1	0.1%
Other values (348)	348	36.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	593	62.4%
300	1	0.1%
2695.9	1	0.1%
2700.84	1	0.1%
2731.81	1	0.1%
2735.55	1	0.1%
2802.39	1	0.1%
2826.01	1	0.1%
2940.84	1	0.1%
2967.32	1	0.1%

Value	Count	Frequency (%)
7730.64	1	0.1%
7710.56	1	0.1%
7700.66	1	0.1%
7695.55	1	0.1%
7693.17	1	0.1%
7685.78	1	0.1%
7685.27	1	0.1%
7683.2	1	0.1%
7678.22	1	0.1%
7661.04	1	0.1%

time_temp_hoch_vorher
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	638
Distinct (%)	67.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2680278.352

Minimum	0
Maximum	11409748.64
Zeros	33
Zeros (%)	3.5%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	0
5-th percentile	139765.7
Q1	793201.45
median	1767303.76
Q3	3737098.882
95-th percentile	8027307.819
Maximum	11409748.64
Range	11409748.64
Interquartile range (IQR)	2943897.432

Descriptive statistics

Standard deviation	2439237.488
Coefficient of variation (CV)	0.9100687197
Kurtosis	0.7340155128
Mean	2680278.352
Median Absolute Deviation (MAD)	1314359.26
Skewness	1.205400973
Sum	2546264435
Variance	5.949879525 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1578427.2	34	3.6%
0	33	3.5%
3739006.82	14	1.5%
1341971.38	12	1.3%
3393493.85	10	1.1%
1497579.63	10	1.1%
3038733.01	9	0.9%
1469602.17	9	0.9%
405011.46	8	0.8%
405611.66	8	0.8%
Other values (628)	803	84.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33	3.5%
17395.4	1	0.1%
17591.57	1	0.1%
17757.17	1	0.1%
17797.63	1	0.1%
18462.93	1	0.1%
18506.4	1	0.1%
18585.12	1	0.1%
21609.26	1	0.1%
35609.14	1	0.1%

Value	Count	Frequency (%)
11409748.64	1	0.1%
10922820.59	1	0.1%
10890510.41	1	0.1%
10377187.11	1	0.1%
10346045.08	1	0.1%
10219232.41	1	0.1%
10186149.51	1	0.1%
9830754.11	1	0.1%
9798870.25	1	0.1%
9651188.08	1	0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	batteryname_	amperestunden	zyklus_	temperature_amax	temperature_amin	temperature_mean	time_amin	time_entladen_stark_vorher	time_entladen_leicht_vorher	time_laden_stark_vorher	time_pause_vorher	time_temp_hoch_vorher
0	RW1	2.000364	3	23.56742	18.39025	21.798768	385232.92	0.00	196178.50	194718.28	0.00	0.00
1	RW1	2.000250	5	24.06639	18.15403	21.449898	405533.19	0.00	203379.98	207816.73	0.00	0.00
2	RW1	1.958481	1009	22.81896	17.57133	20.530506	839519.21	17749.62	312669.57	472156.60	16048.39	178418.56
3	RW1	1.963192	1011	23.64538	18.12253	21.420698	858525.62	17749.62	319737.63	484111.86	16048.39	178418.56
4	RW1	1.911217	1925	23.89487	17.66582	20.839432	1248403.47	36155.14	406768.88	743215.33	28472.48	344313.14
5	RW1	1.915461	1927	23.34912	17.55559	20.933973	1267739.95	36155.14	413665.08	755670.79	28472.48	344313.14
6	RW1	1.869892	2829	23.64538	18.24852	21.355658	1655925.81	53512.10	507852.99	991901.35	43291.22	508390.77
7	RW1	1.866606	2831	22.64744	17.85481	20.966977	1675254.47	53512.10	514573.53	1004497.97	43291.22	508390.77
8	RW1	1.826606	3781	23.31793	18.40600	21.018691	2135722.57	71716.23	607684.52	1325711.87	55716.52	716060.80
9	RW1	1.832734	3783	23.61420	18.92570	21.702610	2154750.80	71716.23	614282.98	1338163.60	55716.52	716060.80

Last rows

	batteryname_	amperestunden	zyklus_	temperature_amax	temperature_amin	temperature_mean	time_amin	time_entladen_stark_vorher	time_entladen_leicht_vorher	time_laden_stark_vorher	time_pause_vorher	time_temp_hoch	time_temp_hoch_vorher
940	RW9	0.885836	101500	39.52802	35.21501	37.680454	11671142.74	311966.09	3883905.64	4709299.38	964202.21	3189.26	8.559283e+06
941	RW9	0.859189	101504	37.59567	32.32421	35.291661	11699932.70	311966.09	3886998.99	4727400.08	971702.21	3093.35	8.587977e+06
942	RW9	0.824189	104515	37.68842	32.20054	35.518379	11926129.42	314060.12	3952264.57	4823001.00	994867.83	2967.32	8.775022e+06
943	RW9	0.837322	104519	38.24494	32.69522	35.364958	11956170.18	314060.12	3955279.04	4842574.44	1002367.83	3014.47	8.805110e+06
944	RW9	0.778364	107536	37.70388	31.81407	35.174338	12177284.66	315859.21	4018987.09	4929998.11	1029183.27	2802.39	8.985943e+06
945	RW9	0.784939	107540	37.88939	31.96866	35.245658	12207354.10	315859.21	4021813.10	4949765.16	1036683.27	2826.01	9.016036e+06
946	RW9	0.759776	110551	37.79663	32.10779	35.343405	12427168.28	317601.49	4080113.57	5040620.52	1059934.58	2735.55	9.190943e+06
947	RW9	0.758740	110555	37.53384	31.59765	34.768506	12457189.16	317601.49	4082845.38	5060405.85	1067434.58	2731.81	9.220960e+06
948	RW9	0.748778	113572	38.29132	32.40151	35.719393	12672750.22	319549.85	4142731.52	5144349.95	1094276.63	2695.90	9.394390e+06
949	RW9	0.750203	113576	38.86329	32.46334	35.958514	12703478.83	319549.85	4145432.36	5164882.66	1101776.63	2700.84	9.425124e+06

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows